﻿-- =============================================
-- Author:		<Author,XFL>
-- Create date: <Create Date,20111230>
-- Description:	<Description,--修改固定补助>
-- =============================================
CREATE PROCEDURE [dbo].[proc_Employee_FixedAllowance_Update]
(
	@Id int,
	@UserName nvarchar(50),
	@EName nvarchar(50),
	@Amount decimal(18, 2),
	@Memo nvarchar(1000)
)
AS
BEGIN
		Declare @CompanyId int,@DepartmentId int
		Select @CompanyId=CompanyId,@DepartmentId=DepartmentId From Employee Where UserName=@UserName
		
		Update
			 Employee_FixedAllowance 
		Set

			CompanyId = @CompanyId,
			DepartmentId = @DepartmentId,
			UserName = @UserName,
			EName = @EName,
			Amount = @Amount,
			Memo = @Memo,
			CreateDate = getdate()
		Where
			Id = @Id
END
